﻿CREATE PROCEDURE [dbo].[CarregarServicoMarcas]
    @tipo VARCHAR(50)
AS

SELECT DISTINCT LTRIM(RTRIM(Marca)) AS Marca
FROM Servico
WHERE LTRIM(Marca) <> ''
  AND ISNULL(Tipo, '') = ISNULL(@tipo, ISNULL(Tipo, ''))
ORDER BY Marca